Release 10.1A: OpenEdge Getting Started:
Database Essentials
Moving tables
The purpose of the table move utility, PROUTIL TABLEMOVE, is to move a table from one storage area to another. This allows you to balance your I/O or group similar tables. You can run this utility while users are accessing the database, but users will be locked out of the table being moved for the duration of the move. The table move utility requires a significant amount of logging space. This affects the primary recovery and after-image areas. In the primary recovery area, logging of the move process uses three to four times the amount of space occupied by the table itself. If you have not planned accordingly, you run the risk of crashing the database from lack of space in the primary recovery area. Test your table move on a copy of your database before using it against production data.
|
Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |